from tools import *

# list
data, columns = read_excel('test_data/sample_test_for_read.xlsx', ret_type='list')
print(columns)
print(data)
write_excel(data, columns, 'test_data/sample_test_for_write.xlsx', in_type='list', autofit=True)
print('list test ended.\n')

# numpy.array
data, columns = read_excel('test_data/sample_test_for_read.xlsx', ret_type='array')
print(columns)
print(data)
write_excel(data, columns, 'test_data/sample_test_for_write.xlsx', in_type='array', autofit=True)
print('array test ended.\n')

# pandas.DataFrame
data, columns = read_excel('test_data/sample_test_for_read.xlsx', ret_type='df')
print(columns)
print(data)
write_excel(data, columns, 'test_data/sample_test_for_write.xlsx', in_type='df', autofit=True)
print('df test ended.\n')
